module.exports = {
  getArticleList: "SELECT * FROM articles LIMIT ? OFFSET ?", //获取文章列表
  getTotalArticles:
    "SELECT COUNT(*) AS total FROM articles WHERE author = IFNULL(?, author)", //获取文章总数
  getArticleByAuthor: `
  SELECT * FROM articles
  WHERE author = IFNULL(?, author)
  LIMIT ? OFFSET ?
`, //根据作者获取文章列表
};
